import pandas as pd
file1 = '2.xlsx'
file2 = '3.xlsx'

sheet_final = pd.read_excel(file1, 'Sheet1')
sheet_be_merged = pd.read_excel(file2, 'Sheet1')

merged_data = sheet_final.merge(sheet_be_merged[['Person', '身高', '体重', '国籍', '连任次数']], on='Person', how='left')

print(merged_data.columns.tolist())

sheet_final['身高'] = merged_data['身高_y']
sheet_final['体重'] = merged_data['体重_y']
sheet_final['国籍'] = merged_data['国籍_y']
sheet_final['连任次数'] = merged_data['连任次数_y']

with pd.ExcelWriter('2.xlsx') as writer:
    sheet_final.to_excel(writer, sheet_name='Sheet1', index=False)